﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Flow_IsNewDocument_V2]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Flow_IsNewDocument_V2];
GO
CREATE PROCEDURE [dbo].[sproc_Flow_IsNewDocument_V2]
    @DocID int
AS
BEGIN
SET NOCOUNT ON;

IF EXISTS ( SELECT 1 FROM dbo.UDS_Flow_Document WHERE Doc_ID = @DocID AND IsRunning = 0)
    RETURN 1;

RETURN 0; -- Dhe document does not exist or isn't a new one.

END
GO
